{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\u001b[32mimport \u001b[39m\u001b[36mscala.collection.mutable.ListBuffer\n",
       "\u001b[39m\n",
       "\u001b[32mimport \u001b[39m\u001b[36mjava.io._\n",
       "\n",
       "\u001b[39m\n",
       "\u001b[36mlines\u001b[39m: \u001b[32mArray\u001b[39m[\u001b[32mString\u001b[39m] = \u001b[33mArray\u001b[39m(\n",
       "  \u001b[32m\"1.每个数据库有且只有一个（ ）。\"\u001b[39m,\n",
       "  \u001b[32m\"A.次要数据文件\"\u001b[39m,\n",
       "  \u001b[32m\"B.主要数据文件\"\u001b[39m,\n",
       "  \u001b[32m\"C.日志文件\"\u001b[39m,\n",
       "  \u001b[32m\"D.索引文件\"\u001b[39m,\n",
       "  \u001b[32m\"↑答案：B\"\u001b[39m,\n",
       "  \u001b[32m\"2.当前数据库运行在open状态，LISTENER 也正常运行，此刻一个dba 执行如下命令 LSNRCTL> STOP 下面的描述中那个是正确的？\"\u001b[39m,\n",
       "  \u001b[32m\"A.会话只能执行查询操作\"\u001b[39m,\n",
       "  \u001b[32m\"B.连接的会话不允许做任何操作直到监听启动\"\u001b[39m,\n",
       "  \u001b[32m\"C.当前连接的会话不受影响，操作继续\"\u001b[39m,\n",
       "  \u001b[32m\"D.会话断掉，并且当前的事物回滚\"\u001b[39m,\n",
       "\u001b[33m...\u001b[39m\n",
       "defined \u001b[32mclass\u001b[39m \u001b[36mQuestion\u001b[39m\n",
       "\u001b[36mquestions\u001b[39m: \u001b[32mListBuffer\u001b[39m[\u001b[32mwrapper\u001b[39m.\u001b[32mwrapper\u001b[39m.\u001b[32mQuestion\u001b[39m] = \u001b[33mListBuffer\u001b[39m(\n",
       "  \u001b[33mQuestion\u001b[39m(\u001b[32m\"1.每个数据库有且只有一个（ ）。\"\u001b[39m, \u001b[32m\"B\"\u001b[39m, \u001b[32m\"次要数据文件\"\u001b[39m, \u001b[32m\"主要数据文件\"\u001b[39m, \u001b[32m\"日志文件\"\u001b[39m, \u001b[32m\"索引文件\"\u001b[39m, \u001b[32m\"\"\u001b[39m, \u001b[32m\"\"\u001b[39m),\n",
       "  \u001b[33mQuestion\u001b[39m(\n",
       "    \u001b[32m\"2.当前数据库运行在open状态，LISTENER 也正常运行，此刻一个dba 执行如下命令 LSNRCTL> STOP 下面的描述中那个是正确的？\"\u001b[39m,\n",
       "    \u001b[32m\"C\"\u001b[39m,\n",
       "    \u001b[32m\"会话只能执行查询操作\"\u001b[39m,\n",
       "    \u001b[32m\"连接的会话不允许做任何操作直到监听启动\"\u001b[39m,\n",
       "    \u001b[32m\"当前连接的会话不受影响，操作继续\"\u001b[39m,\n",
       "    \u001b[32m\"会话断掉，并且当前的事物回滚\"\u001b[39m,\n",
       "    \u001b[32m\"\"\u001b[39m,\n",
       "\u001b[33m...\u001b[39m\n",
       "\u001b[36mtitle\u001b[39m: \u001b[32mString\u001b[39m = \u001b[32m\"\"\u001b[39m\n",
       "\u001b[36manswer\u001b[39m: \u001b[32mString\u001b[39m = \u001b[32m\"\"\u001b[39m\n",
       "\u001b[36ma\u001b[39m: \u001b[32mString\u001b[39m = \u001b[32m\"\"\u001b[39m\n",
       "\u001b[36mb\u001b[39m: \u001b[32mString\u001b[39m = \u001b[32m\"\"\u001b[39m\n",
       "\u001b[36mc\u001b[39m: \u001b[32mString\u001b[39m = \u001b[32m\"\"\u001b[39m\n",
       "\u001b[36md\u001b[39m: \u001b[32mString\u001b[39m = \u001b[32m\"\"\u001b[39m\n",
       "\u001b[36me\u001b[39m: \u001b[32mString\u001b[39m = \u001b[32m\"\"\u001b[39m\n",
       "\u001b[36mf\u001b[39m: \u001b[32mString\u001b[39m = \u001b[32m\"\"\u001b[39m\n",
       "\u001b[36mquestion\u001b[39m: \u001b[32mwrapper\u001b[39m.\u001b[32mwrapper\u001b[39m.\u001b[32mQuestion\u001b[39m = \u001b[33mQuestion\u001b[39m(\u001b[32m\"\"\u001b[39m, \u001b[32m\"\"\u001b[39m, \u001b[32m\"\"\u001b[39m, \u001b[32m\"\"\u001b[39m, \u001b[32m\"\"\u001b[39m, \u001b[32m\"\"\u001b[39m, \u001b[32m\"\"\u001b[39m, \u001b[32m\"\"\u001b[39m)\n",
       "\u001b[36mstrCSV\u001b[39m: \u001b[32mString\u001b[39m = \u001b[32m\"\"\"\n",
       "1.每个数据库有且只有一个（ ）。\tB\t次要数据文件\t主要数据文件\t日志文件\t索引文件\t\t\n",
       "2.当前数据库运行在open状态，LISTENER 也正常运行，此刻一个dba 执行如下命令 LSNRCTL> STOP 下面的描述中那个是正确的？\tC\t会话只能执行查询操作\t连接的会话不允许做任何操作直到监听启动\t当前连接的会话不受影响，操作继续\t会话断掉，并且当前的事物回滚\t\t\n",
       "3.onstat -g act命令是用于显示___\tC\tVP信息\t所有线程信息\t当前活动线程\t\t\t\n",
       "4.HDR集群中参数DRAUTO设置为2，若此时关闭HDR主机，则___\tA\tHDR备用数据库将转换为主用模式，原HDR主用恢复成备用模式\t由连接管理器中的FOC切换规则来切换\tHDR备用数据库将保持为备用模式，在主用恢复后自动恢复HDR连接\tHDR备用数据库将转换为标准模式，在主用恢复后自动转换为备用恢复HDR连接\t\t\n",
       "5.下列关于Oracle支持的锁粒度描述正确的是？\tA\t数据库级、表级、行级、列级\t数据库级、表级、行级\t行级、列级\t列级、表级\t\t\n",
       "6.当执行一个存储过程时，服务器到哪里查询该存储过程( )\tD\tmodel\tmaster\tsybsystemdb\tsybsystemprocs\t\t\n",
       "7.作为一个ORACLE DBA，你运行以下的SQL命令查询ASM实例，查询结果的含义是什么？ SQL> select group_number, name, state from v$ASM_DISKGROUP; GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROU\u001b[33m...\u001b[39m\n",
       "\u001b[36mwriter\u001b[39m: \u001b[32mPrintWriter\u001b[39m = java.io.PrintWriter@6547f283"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import scala.collection.mutable.ListBuffer\n",
    "import java.io._\n",
    "\n",
    "val lines = content.split(\"\\n\").map(s =>s.trim()).filter(s => s.length() > 0)\n",
    "\n",
    "case class Question(title: String = \"\", answer: String = \"\", a: String = \"\", b: String = \"\" , c: String = \"\", d: String = \"\", e: String = \"\", f: String = \"\")\n",
    "\n",
    "val questions = ListBuffer[Question]()\n",
    "\n",
    "var title = \"\"\n",
    "var answer = \"\"\n",
    "var a = \"\"\n",
    "var b = \"\"\n",
    "var c = \"\"\n",
    "var d = \"\"\n",
    "var e = \"\"\n",
    "var f = \"\"\n",
    "var question = Question()\n",
    "lines.foreach{ s =>\n",
    "    if (s.startsWith(\"A.\")) {\n",
    "        a = s.split(\"\\\\.\").drop(1).mkString(\".\")\n",
    "    } else if (s.startsWith(\"B.\")) {\n",
    "        b = s.split(\"\\\\.\").drop(1).mkString(\".\")\n",
    "    } else if (s.startsWith(\"C.\")) {\n",
    "        c = s.split(\"\\\\.\").drop(1).mkString(\".\")\n",
    "    } else if (s.startsWith(\"D.\")) {\n",
    "        d = s.split(\"\\\\.\").drop(1).mkString(\".\")\n",
    "    } else if (s.startsWith(\"E.\")) {\n",
    "        e = s.split(\"\\\\.\").drop(1).mkString(\".\")\n",
    "    } else if (s.startsWith(\"F.\")) {\n",
    "        f = s.split(\"\\\\.\").drop(1).mkString(\".\")\n",
    "    } else if (s.startsWith(\"↑答案\")) {\n",
    "        answer = s.replace(\"↑答案：\", \"\")\n",
    "        val question = new Question(title=title, answer=answer, a=a, b=b, c=c, d=d, e=e, f=f)\n",
    "        questions += question\n",
    "        title = \"\"\n",
    "        a = \"\"\n",
    "        b = \"\"\n",
    "        c = \"\"\n",
    "        d = \"\"\n",
    "        e = \"\"\n",
    "        f = \"\"\n",
    "        answer = \"\"\n",
    "    } else {\n",
    "        title += s\n",
    "    }\n",
    "}\n",
    "\n",
    "val strCSV = questions.map{q =>\n",
    "    s\"\"\"${q.title}\\t${q.answer}\\t${q.a}\\t${q.b}\\t${q.c}\\t${q.d}\\t${q.e}\\t${q.f}\"\"\"\n",
    "}.mkString(\"\\n\")\n",
    "\n",
    "val writer = new PrintWriter(new File(\"output2.csv\"))\n",
    "writer.write(strCSV)\n",
    "writer.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "val content = \"\"\"\n",
    "1.每个数据库有且只有一个（ ）。\n",
    "A.次要数据文件\n",
    "B.主要数据文件\n",
    "C.日志文件\n",
    "D.索引文件\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "2.当前数据库运行在open状态，LISTENER 也正常运行，此刻一个dba 执行如下命令 LSNRCTL> STOP 下面的描述中那个是正确的？\n",
    "A.会话只能执行查询操作\n",
    "B.连接的会话不允许做任何操作直到监听启动\n",
    "C.当前连接的会话不受影响，操作继续\n",
    "D.会话断掉，并且当前的事物回滚\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "3.onstat -g act命令是用于显示___\n",
    "A.VP信息\n",
    "B.所有线程信息\n",
    "C.当前活动线程\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "4.HDR集群中参数DRAUTO设置为2，若此时关闭HDR主机，则___\n",
    "A.HDR备用数据库将转换为主用模式，原HDR主用恢复成备用模式\n",
    "B.由连接管理器中的FOC切换规则来切换\n",
    "C.HDR备用数据库将保持为备用模式，在主用恢复后自动恢复HDR连接\n",
    "D.HDR备用数据库将转换为标准模式，在主用恢复后自动转换为备用恢复HDR连接\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "5.下列关于Oracle支持的锁粒度描述正确的是？\n",
    "A.数据库级、表级、行级、列级\n",
    "B.数据库级、表级、行级\n",
    "C.行级、列级\n",
    "D.列级、表级\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "6.当执行一个存储过程时，服务器到哪里查询该存储过程( )\n",
    "A.model\n",
    "B.master\n",
    "C.sybsystemdb\n",
    "D.sybsystemprocs\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "7. \n",
    "作为一个ORACLE DBA，你运行以下的SQL命令查询ASM实例，查询结果的含义是什么？ SQL> select group_number, name, state from v$ASM_DISKGROUP; GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTED\n",
    "\n",
    "A.DGROUP1磁盘组被其他的DBA卸载了\n",
    "B.一个多余的磁盘（DGROUP1）将在磁盘组中丢失\n",
    "C.一个数据文件丢失，原因是DGROUP1磁盘组正在进入DISMOUNTED状态\n",
    "D.这个查询在ASM实例中没有意义\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "8.IDS存储中分配给服务器的一个连续的磁盘空间的单位是___\n",
    "A.chunk\n",
    "B.dbspaces\n",
    "C.page\n",
    "D.extent\n",
    "E.tblsapces\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "9.为了查看SQL Server对系统资源的使用情况，可以启动系统监视器监视。在Windows中如何启动系统监视器（ ）。\n",
    "A.在“开始”菜单上，指定“运行”，在“运行”对话框中键入taskmgr，然后单击“确定”\n",
    "B.在“开始”菜单上，指定“运行”，在“运行”对话框中键入perfmon，然后单击“确定”\n",
    "C.在“开始”菜单上，指定“运行”，在“运行”对话框中键入mstsc，然后单击“确定”\n",
    "D.在“开始”菜单上，指定“运行”，在“运行”对话框中键入services.msc，然后单击“确定”\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "10. \n",
    "MYSQL数据库中以下哪条语句可以找到处于同一状态超过180秒的连接？\n",
    "\n",
    "A.SHOW FULL PROCESSLIST WHEER Time > 180;\n",
    "B.SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB(NOW(), INTERVAL 180 SECOND));\n",
    "C.SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;\n",
    "D.SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE STARTS < (DATE_SUB(NOW(), INTERVAL 180 SECOND));\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "11.SQL Server中表查询的命令是（ ）。\n",
    "A.UPDATE\n",
    "B.SELECT\n",
    "C.DROP\n",
    "D.USE\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "12. \n",
    "在informix数据库下显示消息日志后20行的命令\n",
    "\n",
    "A.onstat -d\n",
    "B.onstat -m\n",
    "C.onstat -k\n",
    "D.onstat -l\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "13.在日常维护中，为了简化A户的查询操作，而又不增加数据的存储空间，常用的方法是创建（）\n",
    "A.游标（CURSOR）\n",
    "B.索引（INDEX）\n",
    "C.视图（VIEW）\n",
    "D.另一个表（TABLE）\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "14.ORACLE数据库自带的opath工具在下面那个目录下？\n",
    "A.$ORACLE_HOME/network/admin\n",
    "B.$ORACLE_HOME/bin\n",
    "C.$ORACLE_HOME/OPAtch\n",
    "D.$ORACLE_BASE\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "15.onstat -g ath命令是用语显示___\n",
    "A.当前活动线程\n",
    "B.VP信息\n",
    "C.所有线程信息\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "16. \n",
    "当informix客户端应用和数据库服务器处于同一个主机上时,以下最佳连接到数据库服务器的方法是___\n",
    "\n",
    "A.通过流通道\n",
    "B.通过共享内存\n",
    "C.通过套接字\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "17. \n",
    "informix数据库中显示表或分段表的表空间信息命令\n",
    "\n",
    "A.oncheck -pe\n",
    "B.oncheck -pt\n",
    "C.oncheck -pp\n",
    "D.oncheck -pr\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "18.IDS中物理日志用于___\n",
    "A.事务记录\n",
    "B.快速恢复\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "19.HDR集群中参数DRAUTO设置为3，若此时关闭HDR主机，则___\n",
    "A.HDR备用数据库将转换为主用模式，原HDR主用恢复成备用模式\n",
    "B.由连接管理器中的FOC切换规则来切换\n",
    "C.HDR备用数据库将转换为标准模式，在主用恢复后自动转换为备用恢复HDR连接\n",
    "D.HDR备用数据库将保持为备用模式，在主用恢复后自动恢复HDR连接\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "20.IDS中缓冲池位于共享内存中的___\n",
    "A.虚拟内存\n",
    "B.消息内存\n",
    "C.常驻内存\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "21.IDS中用于运行I/O活动以及磁盘读写的VP类型是___\n",
    "A.aio\n",
    "B.adm\n",
    "C.cpu\n",
    "D.lio\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "22.数据库运行在非归档状态下，目前计划切换到归档模式，有下面的操作步骤。 1. 关闭实例 2. 执行 ALTER DATABASE ARCHIVELOG 3. 启动实例mount 数据库 4. 设置DB_RECOVERY_FILE_DEST参数指向 $ORACLE_HOME/dest_1. 5. 打开数据库以上是没有按照顺序列出的操作，正确的顺序为：\n",
    "A.1, 3, 4, 5, 2\n",
    "B.4, 1, 3, 2, 5\n",
    "C.1, 3, 2, 5; 4 not required\n",
    "D.4, 1, 5, 2; 3 not required\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "23.Sybase错误日志包含错误消息的文本文件，它默认位于哪个目录下( )\n",
    "A./sybase/bin\n",
    "B./sybase/tmp\n",
    "C./sybase/ASE-12_0/\n",
    "D./sybase/ASE-12_0/install目录中\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "24.下列哪一个锁模式不属于Oracle?\n",
    "A.共享锁\n",
    "B.排它锁\n",
    "C.死锁\n",
    "D.行级共享锁\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "25.你的数据库运行在归档模式下，有两组reodo log，每组包含一个成员。当你试图启动这个数据库时，你得到了下面的错误提示： ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ''D:\\REDO01.LOG'' 你发现当前redo log文件损坏了，你应该使用下面哪句命令来解决此问题？\n",
    "A.ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;\n",
    "B.ALTER DATABASE CLEAR LOGFILE GROUP 1;\n",
    "C.ALTER DATABASE DROP LOGFILE GROUP 1;\n",
    "D.ALTER DATABASE DROP LOGFILE MEMBER ''D:\\REDO01.LOG'';\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "26.能够统计表中计算平均值的函数是\n",
    "A.COUNT\n",
    "B.TO_NUMBER\n",
    "C.AVG\n",
    "D.SUBSTR\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "27.一下那个不是数据库的物理组件？\n",
    "A.控制文件\n",
    "B.数据文件\n",
    "C.日志文件\n",
    "D.表空间\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "28.SQL Server 系统中的所有服务器级系统信息存储于哪个数据库（ ）。\n",
    "A.model\n",
    "B.tempdb\n",
    "C.master\n",
    "D.msdb\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "29.IDS高可用复制系统(HDR)中，备机用于接收逻辑日志的共享内存缓冲区为___\n",
    "A.接收缓冲区\n",
    "B.逻辑日志缓冲区\n",
    "C.HDR发送缓冲区\n",
    "D.恢复缓冲区\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "30.IDS中保留页位于___\n",
    "A.物理日志空间\n",
    "B.逻辑日志空间\n",
    "C.根空间\n",
    "D.数据空间\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "31. \n",
    "oracle数据库中下面哪种类型的锁用于锁定表，仅允许其他用户查询表中的行，而不允许插入、更新或删除行\n",
    "\n",
    "A.排他\n",
    "B.不存在这种锁\n",
    "C.共享\n",
    "D.共享更新\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "32.下列哪一项不是一个角色？\n",
    "A.CONNECT\n",
    "B.CREATE SESSION\n",
    "C.RESOURCE\n",
    "D.DBA\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "33.下列哪个不是 sql 数据库文件的后缀。（ ）\n",
    "A..ndf\n",
    "B..tif\n",
    "C..mdf\n",
    "D..ldf\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "34.在Oracle中，哪个操作符返回并集操作并不包括重复行。\n",
    "A.Minus\n",
    "B.Intersect\n",
    "C.Union\n",
    "D.Union all\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "35.一个IDS中运行adm类型的VP有几个\n",
    "A.4个\n",
    "B.1个\n",
    "C.3个\n",
    "D.2个\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "36.显示数据库空间使用情况的命令\n",
    "A.onstat -l\n",
    "B.onstat -m\n",
    "C.onstat -k\n",
    "D.onstat -d\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "37.MS SQL SERVER用来显示数据库信息的系统储存过程是（ ）。\n",
    "A.sp_db\n",
    "B.sp_dbhelp\n",
    "C.sp_help\n",
    "D.sp_helpdb\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "38.向用户授予操作权限的 SQL 语句是（ ）。\n",
    "A.GRANT\n",
    "B.CTEATE\n",
    "C.SELECT\n",
    "D.REVOKE\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "39.如果要修改表的结构，应该使用 SQL 语言的命令（ ）。\n",
    "A.ALTER TABLE\n",
    "B.UPDATE TABLE\n",
    "C.CHANGE TABLE\n",
    "D.MODIFY TABLE\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "40.Oracle中，下面什么函数将char或varchar数据类型转换为date数据类型？\n",
    "A.date\n",
    "B.to_date\n",
    "C.ctodate\n",
    "D.todate\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "41. \n",
    "在informix下，dbexport中指定导出到系统目录的参数是___\n",
    "\n",
    "A.t\n",
    "B.c\n",
    "C.o\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "42.若IDS环境变量配置为ONCONFIG=onconfig，那么onconfig文件位于___\n",
    "A./etc\n",
    "B.$HOME/etc\n",
    "C.$INFORMIXDIR/etc\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "43. \n",
    "在oracle数据库中，能够统计表中记录行数的函数是？\n",
    "\n",
    "A.AVG\n",
    "B.TO_NUMBER\n",
    "C.COUNT\n",
    "D.SUBSTR\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "44.IDS中用于运行服务器写入逻辑日志的VP类型是___\n",
    "A.cpu\n",
    "B.lio\n",
    "C.adm\n",
    "D.aio\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "45.IDS存储中基本的I/O单位是___\n",
    "A.extent\n",
    "B.page\n",
    "C.chunk\n",
    "D.dbspaces\n",
    "E.tblspaces\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "46.SMI表中用于记录所有DB中的表的表名是___\n",
    "A.syslogs\n",
    "B.sysdatabases\n",
    "C.sysdbspaces\n",
    "D.systabnames\n",
    "E.syschunks\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "47. \n",
    "为确保操作安全，在进行oracle数据库大版本升级前需要对db 的那些文件进行备份？\n",
    "\n",
    "A.$ORACLE_HOME\n",
    "B.控制文件\n",
    "C.所有文件\n",
    "D.所有数据文件\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "48.sysfragments位于___\n",
    "A.系统目录表\n",
    "B.SMI表\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "49.对于数据库的管理，SQL Server 的授权系统将用户分成四类，其中权限最大的用户是（ ）。\n",
    "A.系统管理员\n",
    "B.数据库拥有者\n",
    "C.一般用户\n",
    "D.数据库对象拥有者\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "50.SQL Server 中表更新数据的命令是（ ） 。\n",
    "A.USE\n",
    "B.DROP\n",
    "C.UPDATE\n",
    "D.SELECT\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "51. \n",
    "在informix数据库中，以下远程连接到数据库服务器的最佳方法是___\n",
    "\n",
    "A.通过共享内存\n",
    "B.通过流通道\n",
    "C.通过套接字\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "52. \n",
    "informix数据库中syslogs表中记录的是___\n",
    "\n",
    "A.物理日志信息\n",
    "B.所有日志信息\n",
    "C.逻辑日志信息\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "53.IDS中session pool位于共享内存中的___\n",
    "A.常驻内存\n",
    "B.虚拟内存\n",
    "C.消息内存\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "54.你有3个控制文件，某天发现丢失一个，为了恢复这个控制文件，下面步骤正确的是？ a. 关闭数据库 b. 从一个备份介质中恢复一个控制文件。 c. 使用创建控制文件的命令重新创建一个新的控制文件。 d. 通过未丢失的控制文件复制一个新的控制文件。 e. 恢复数据库使用recover database using backup controlfile命令。 f. 启动数据库\n",
    "A.a, d, f\n",
    "B.c, e, f s\n",
    "C.a, b, e, f\n",
    "D.a, e, f\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "55.SQL Server是一种（ ）软件。\n",
    "A.数据库管理系统\n",
    "B.服务性程序\n",
    "C.操作系统\n",
    "D.语言处理\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "56.在哪里可以查看SQL Server 2008中的当前日志（ ）。\n",
    "A.SQL Server Management Studio中的管理——SQL Server日志\n",
    "B.SQL Server Management Studio中的管理——维护计划\n",
    "C.SQL Server Management Studio中的安全性——SQL Server日志\n",
    "D.SQL Server Management Studio中的数据库——SQL Server日志\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "57. \n",
    "在做一个informix数据库的迁移的时候，导出比较合适的方式是___\n",
    "\n",
    "A.外部表\n",
    "B.HPL\n",
    "C.dbexport\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "58.SQL Server数据库提供的错误信息如何查看？（ ）\n",
    "A.查看系统视图sys.database_files\n",
    "B.查看系统视图sys.stats\n",
    "C.查看系统视图sys.error\n",
    "D.查看系统视图sys.messages\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "59.命令onmode -d make primary SERVER是针对___集群关系使用\n",
    "A.SDS\n",
    "B.RSS\n",
    "C.HDR\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "60.使用immediate 选项关闭数据库，在下次打开数据库的时候下面一些项可能会发生 1.分配sga 2.读控制文件 3.打开redo日志文件 4. 实例开始恢复 5.启动后台进程 6. 检查数据文件头是否一致 7. 读参数文件（服务端参数文件或者本地参数文件）上面描述的那些项会发生，按启动顺序？\n",
    "A.1, 2, 3, 5, 6, 4; step 7 is not required\n",
    "B.7, 1, 5, 2, 3, 6, 4\n",
    "C.7, 1, 5, 2, 3, 6; step 4 is not required\n",
    "D.1, 5, 7, 2, 3, 6; step 4 is not required\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "61. \n",
    "在Oracle数据库中，下列哪项操作可以显示当前数据库已安装的补丁信息？\n",
    "\n",
    "A.opatch lsinventory\n",
    "B.opatch apply\n",
    "C.opatch rollback\n",
    "D.opatch prereq\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "62.IDS高可用复制系统(HDR)中，主机用于发送逻辑日志的共享内存缓冲区为___\n",
    "A.恢复缓冲区\n",
    "B.接收缓冲区\n",
    "C.逻辑日志缓冲区\n",
    "D.HDR发送缓冲区\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "63.IDS中逻辑日志用于___\n",
    "A.快速恢复\n",
    "B.事务记录\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "64.SQL Server网络库中TCP/IP套接字所使用的端口号是（ ）。\n",
    "A.8080\n",
    "B.1433\n",
    "C.80\n",
    "D.2433\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "65. \n",
    "给oracle数据库打补丁的时候使用下面哪项命令：\n",
    "\n",
    "A.opatch rollback\n",
    "B.opatch util\n",
    "C.opatch prereq\n",
    "D.opatch apply\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "66.db在什么状态下打psu?\n",
    "A.mount\n",
    "B.read only\n",
    "C.关闭\n",
    "D.open\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "67.用户不小心在生产环境中删除了一张比较重要的表，他想恢复该操作，你会采取什么样的行的？\n",
    "A.从一个测试环境中拷贝这张表\n",
    "B.执行一个Flashback Recovery操作\n",
    "C.使用RMAN进行不完全恢复\n",
    "D.执行一个Flashback Drop操作\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "68.RSS主备机之间事务落实与检查点均是___进行\n",
    "A.同步\n",
    "B.异步\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "69.系统中有权利启动和关闭数据库的用户是\n",
    "A.user\n",
    "B.scott\n",
    "C.hr\n",
    "D.system\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "70. \n",
    "oracle数据库中下列哪个等待事件显示行级锁竞争？\n",
    "\n",
    "A.latch: shared pool\n",
    "B.cursor: pin S wait on X\n",
    "C.enq: TX - row lock contention\n",
    "D.db file scattered read\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "71.IDS中表级恢复实用程序是\n",
    "A.onbar\n",
    "B.ontape\n",
    "C.archecker\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "72.下面哪种情景需要使用静态监听？\n",
    "A.用户连接通过主机名方式连接数据库\n",
    "B.多个数据库注册到监听上\n",
    "C.dba 需要远程登录重启数据库\n",
    "D.需要配置数据库连接方式为共享模式\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "73. \n",
    "显示informix数据库保留页信息的命令\n",
    "\n",
    "A.oncheck -pt\n",
    "B.oncheck -pe\n",
    "C.oncheck -pp\n",
    "D.oncheck -pr\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "74.db file sequential read等待P3 参数的含义是？\n",
    "A.访问的数据块号\n",
    "B.访问的文件号\n",
    "C.访问的数据块数量\n",
    "D.访问的文件名\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "75.SMI表中用于记录服务器上所有的DB的表名是___\n",
    "A.sysdbspaces\n",
    "B.sysdatabases\n",
    "C.syschunks\n",
    "D.systabnames\n",
    "E.syslogs\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "76.db file sequential read等待P1 参数的含义是？\n",
    "A.访问的文件名\n",
    "B.访问的文件号\n",
    "C.访问的数据块号\n",
    "D.文件拥有者\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "77.在需要恢复日志空间或者跟空间的时候实例的状态应该是___\n",
    "A.online\n",
    "B.offline\n",
    "C.quiescent\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "78.10G以上版本v$session中那个字段表示当前进程的等待事件？\n",
    "A.events\n",
    "B.sid\n",
    "C.event\n",
    "D.sql_id\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "79.用户在一张表上执行一个更新操作，提交不久后，发现他们的WHERE子句中有一个错误，导致错误的行被更新了。下面哪一个闪回选项将允许你撤销此交易，并恢复该表到以前的状态？\n",
    "A.Flashback Query\n",
    "B.Flashback Table\n",
    "C.Flashback Transaction Query\n",
    "D.Flashback Versions Query\n",
    "E.Flashback Drop\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "80.哪个命令可停止数据库Adaptive Server服务器\n",
    "A.shutdown\n",
    "B.startserver\n",
    "C.sp_helpsort\n",
    "D.showserver\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "81.SQL语言中，仅删除表中数据的命令是（ ）。\n",
    "A.DROP\n",
    "B.DELECT\n",
    "C.CLEAR\n",
    "D.REMOVE\n",
    "\n",
    "\n",
    "↑答案：B\n",
    "\n",
    "\n",
    "82. \n",
    "在SQL Server中，建表使用的命令是（ ）。\n",
    "\n",
    "A.CREAT TABLE\n",
    "B.CREAT SCHEMA\n",
    "C.CREAT INDEX\n",
    "D.CREAT VIEW\n",
    "\n",
    "\n",
    "↑答案：A\n",
    "\n",
    "\n",
    "83. \n",
    "在oracle数据库中，db file sequential read等待P2 参数的含义是？\n",
    "\n",
    "A.访问的文件名\n",
    "B.访问的文件号\n",
    "C.文件拥有者\n",
    "D.访问的数据块号\n",
    "\n",
    "\n",
    "↑答案：D\n",
    "\n",
    "\n",
    "84.显示数据库日志使用情况的命令\n",
    "A.onstat -m\n",
    "B.onstat -d\n",
    "C.onstat -l\n",
    "D.onstat -k\n",
    "\n",
    "\n",
    "↑答案：C\n",
    "\n",
    "\n",
    "85.Adaptive Server需要以下哪些数据库才能正常工作( )\n",
    "A.sybsystemdb\n",
    "B.master\n",
    "C.tempdb\n",
    "D.model\n",
    "E.sybsystemprocs\n",
    "\n",
    "\n",
    "↑答案：ABCDE\n",
    "\n",
    "\n",
    "86. \n",
    "在oracle数据库中创建一个角色实现下面的要求角色防止非经授权使用角色的密码不用嵌入到应用程序中或者存储到表中以下哪种方式不可以限制该角色？\n",
    "\n",
    "A.创建外部授权角色\n",
    "B.创建密码保护角色\n",
    "C.创建安全应用角色\n",
    "D.采用Fine-Grained Access Control (FGAC) 创建安全角色\n",
    "\n",
    "\n",
    "↑答案：ABD\n",
    "\n",
    "\n",
    "87.以下哪些属于Sybase ASE数据库的附加组件程序（）\n",
    "A.XP Server\n",
    "B.Backup Server\n",
    "C.Data Server\n",
    "D.Monitor Server\n",
    "\n",
    "\n",
    "↑答案：ABD\n",
    "\n",
    "\n",
    "88.以下哪些属于Sybase ASE数据库实用程序（）\n",
    "A.srvbuild\n",
    "B.isql\n",
    "C.onstat\n",
    "D.bcp\n",
    "\n",
    "\n",
    "↑答案：ABD\n",
    "\n",
    "\n",
    "89. \n",
    "oracle数据库中，下面那两个错误会更新到alert 日志？\n",
    "\n",
    "A.运行一个查询，报错ORA-600 内部错误\n",
    "B.ALTER INDEX ...REBUILD重建索引失败，ORA-01578 数据块损坏（file # 14, block # 50）\n",
    "C.创建表报错ORA-00955 ，名字已经存在\n",
    "D.向表中插入一条数据报错，ORA-01722: invalid number\n",
    "\n",
    "\n",
    "↑答案：AB\n",
    "\n",
    "\n",
    "90.用ORDER BY来进行查询时，其排序方式有（ ）。\n",
    "A.DESC\n",
    "B.AAC\n",
    "C.DEAC\n",
    "D.ASC\n",
    "\n",
    "\n",
    "↑答案：AD\n",
    "\n",
    "\n",
    "91.在检查alert log后以下哪两种情况能获得详细信息\n",
    "A.插入表中的值返回“ORA-01722：无效的数字。”\n",
    "B.运行在一个表的查询返回“ORA-600：内部错误”\n",
    "C.插入表中的一行返回“ORA-00060：死锁检测等待的资源。”\n",
    "D.创建一个表返回“ORA-00955：名称已使用现有的对象。”\n",
    "\n",
    "\n",
    "↑答案：BC\n",
    "\n",
    "\n",
    "92.关于Listener的描述错误的是（）\n",
    "A.监听、接收客户端连接请求\n",
    "B.防止黑客入侵\n",
    "C.验证连接数据库用户的身份\n",
    "D.实现客户端与数据库之间的信息传输\n",
    "\n",
    "\n",
    "↑答案：BCD\n",
    "\n",
    "\n",
    "93.SQL Server登录所使用的身份验证模式包括（ ）。\n",
    "A.单用户模式\n",
    "B.SQL Server验证模式\n",
    "C.Windows验证模式\n",
    "D.混合模式（Widndows身份验证和SQL Server身份验证）\n",
    "\n",
    "\n",
    "↑答案：CD\n",
    "\n",
    "\n",
    "94.关于myisamchk工具，以下描述正确的有哪些？\n",
    "A.它能修复MyISAM表\n",
    "B.它能获取MyISAM表的信息\n",
    "C.它能优化MyISAM表\n",
    "D.它能检查MyISAM表\n",
    "\n",
    "\n",
    "↑答案：ABCD\n",
    "\n",
    "\n",
    "95.获取数据库实例名可以通过哪些方式\n",
    "A.DBSERVERNAME配置参数\n",
    "B.DBSERVERALIAES配置参数\n",
    "C.INFORMIXSERVER环境变量\n",
    "D.SERVERNUM配置参数\n",
    "\n",
    "\n",
    "↑答案：ABC\n",
    "\n",
    "\n",
    "96. \n",
    "   有关ORACLE alert 的描述正确的两项是？\n",
    "\n",
    "A.数据库一般告警不会自动解决，需要管理员进行处理\n",
    "B.响应操作服务器无发生成告警\n",
    "C.在非临界点告警出现在DBA_OUTSTANDING_ALERTS视图\n",
    "D.清理alert ，另存储到历史告警位置\n",
    "\n",
    "\n",
    "↑答案：AD\n",
    "\n",
    "\n",
    "97.有关监听下列那两个说法是正确的\n",
    "A.多个数据库实例可以注册与单个侦听器\n",
    "B.监听器仅使用TCP / IP协议\n",
    "C.监听器相关的错误只能在管理级别进行跟踪\n",
    "D.多个监听进程可以在主机上同时运行\n",
    "\n",
    "\n",
    "↑答案：AD\n",
    "\n",
    "\n",
    "98.IDS中存储的物理概念有\n",
    "A.dbspaces\n",
    "B.extent\n",
    "C.chunk\n",
    "D.page\n",
    "\n",
    "\n",
    "↑答案：CD\n",
    "\n",
    "\n",
    "99.onstat -g seg输出中class字段中用语表示常驻内存和虚拟内存的标志是___\n",
    "A.R\n",
    "B.M\n",
    "C.V\n",
    "\n",
    "\n",
    "↑答案：AC\n",
    "\n",
    "\n",
    "100.下面哪个用户不是ORACLE缺省安装后就存在的用户\n",
    "A.SCOTT\n",
    "B.SYSDBA\n",
    "C.SYSTEM\n",
    "D.SYSOPER\n",
    "\n",
    "\n",
    "↑答案：BD\n",
    "\n",
    "\n",
    "101.下面那些等待事件表示空闲等待？\n",
    "A.SQL*Net message to client\n",
    "B.SQL*Net message from client\n",
    "C.library cache lock\n",
    "D.log file sync\n",
    "\n",
    "\n",
    "↑答案：AB\n",
    "\n",
    "\n",
    "102.Adaptive Server错误日志error log日志文件中的显示条目格式有哪些内容( )\n",
    "A.引擎号\n",
    "B.错误消息\n",
    "C.日期时间\n",
    "D.线程号\n",
    "E.发送者\n",
    "\n",
    "\n",
    "↑答案：ABCDE\n",
    "\n",
    "\n",
    "103.下列有关监听说法正确的两项是\n",
    "A.仅仅一个数据库可以在任何时候注册在单独的监听上\n",
    "B.监听器相关的错误只能在管理级别进行跟踪\n",
    "C.多个数据库实例可以注册在同一监听上\n",
    "D.监听这只能使用TCP/IP端口\n",
    "E.多个监听可以同时监听一个地址\n",
    "\n",
    "\n",
    "↑答案：CE\n",
    "\n",
    "\n",
    "104.以下哪些属于系统管理员职责( )\n",
    "A.备份数据库\n",
    "B.恢复数据库\n",
    "C.为数据库与它们中的对象分配硬盘资源\n",
    "D.创建与配置服务器\n",
    "E.创建数据库\n",
    "\n",
    "\n",
    "↑答案：ABCDE\n",
    "\n",
    "\n",
    "105.数据库实例上线必须配置的环境变量\n",
    "A.INFORMIXSERVER\n",
    "B.INFORMIXDIR\n",
    "C.SQLHOSTS\n",
    "D.ONCONFIG\n",
    "\n",
    "\n",
    "↑答案：ABD\n",
    "\n",
    "\n",
    "106.下面有关Automatic Database Diagnostic Monitor (ADDM) 的描述中，那两项是正确的？\n",
    "A.ADDM 仅提供诊断分析，不提供建议\n",
    "B.ADDM 分析结果存放在Automatic Workload Repository中\n",
    "C.ADDM 是MMON进程在每次 awr 快照收集后 自动运行\n",
    "D.ADDM 可以调用其它建议如果需要，但是不会产生推荐建议\n",
    "E.ADDM至少需要4个awr 快照进行分析\n",
    "\n",
    "\n",
    "↑答案：BC\n",
    "\n",
    "\n",
    "107.关于数据库ADDM说法正确的两项是\n",
    "A.ADDM分析需要最近的4个AWR快照\n",
    "B.ADDM的分析结果存储在AWR报告中\n",
    "C.ADDM运行在mmon自动采集AWR快照之后\n",
    "D.ADDM分析只提供诊断信息，但不提供建议\n",
    "E.如果需要，ADDM调用其他顾问，但不提供顾问建议\n",
    "\n",
    "\n",
    "↑答案：BC\n",
    "\n",
    "\n",
    "108.onstat -g dri与onstat -g sds分别用于输出___\n",
    "A.共享磁盘集群信息\n",
    "B.远程独立集群信息\n",
    "C.高可用性集群信息\n",
    "\n",
    "\n",
    "↑答案：AC\n",
    "\n",
    "\n",
    "109.Adaptive Server遇到错误问题时，会有相关问题的信息、问题的严重程度以及如何解决，那么错误消息由一下哪些内容组成（ )\n",
    "A.严重级号\n",
    "B.错误状态号\n",
    "C.错误消息\n",
    "D.消息号\n",
    "\n",
    "\n",
    "↑答案：ABCD\n",
    "\n",
    "\n",
    "110.关于单行函数，以下哪两个说法是正确的？\n",
    "A.参数只能是列值或内容\n",
    "B.最多嵌套二层\n",
    "C.只能返回一个单行结果\n",
    "D.只能接收一个参数\n",
    "E.能返回与参数类型不同的值\n",
    "\n",
    "\n",
    "↑答案：CE\n",
    "\n",
    "\n",
    "111.SQL Server对数据库备份的方法（ ）。\n",
    "A.差异备份\n",
    "B.完全数据库备份\n",
    "C.事务日志备份\n",
    "D.数据库文件或文件组备份\n",
    "\n",
    "\n",
    "↑答案：ABCD\n",
    "\n",
    "\n",
    "112. \n",
    "Oracle数据中，下列哪些等待事件将产生大量的IO？\n",
    "\n",
    "A.log file parallel write\n",
    "B.latch: cache buffers chains\n",
    "C.db file sequential read\n",
    "D.db file scattered read\n",
    "\n",
    "\n",
    "↑答案：CD\n",
    "\n",
    "\n",
    "113.下面有关undo表空间的描述中那两项是正确的 ？\n",
    "A.undo表空间按照需要自动扩展和收缩，对于给定的事物可以循环利用\n",
    "B.数据库可以有多个undo 表空间\n",
    "C.如果UNDO_TABLESPACE没有设置，且UNDO_MANAGEMENT设置为AUTO,则启动数据库的时自动创建udno 表空间\n",
    "D.UNDO_TABLESPACE参数可以设置为手动和自动管理方式\n",
    "\n",
    "\n",
    "↑答案：AB\n",
    "\n",
    "\n",
    "114.systables中可以判定属于用户表的条件\n",
    "A.tabname前三个字符不是sys\n",
    "B.tabid大于99\n",
    "C.tabname前三个字符是sys\n",
    "D.tabid大于98\n",
    "\n",
    "\n",
    "↑答案：AB\n",
    "\n",
    "\n",
    "115. \n",
    "informix数据库HPL中导入导出的参数是___\n",
    "\n",
    "A.i\n",
    "B.fu\n",
    "C.o\n",
    "D.fl\n",
    "\n",
    "\n",
    "↑答案：BD\n",
    "\n",
    "\n",
    "116. \n",
    "在informix数据库下，对表做迁移时，一般选用的工具是\n",
    "\n",
    "A.dbexport\n",
    "B.HPL\n",
    "C.load/unload\n",
    "\n",
    "\n",
    "↑答案：BC\n",
    "\n",
    "\n",
    "117.IDS中的备份与恢复实用程序有\n",
    "A.onbar\n",
    "B.onlog\n",
    "C.ontape\n",
    "\n",
    "\n",
    "↑答案：AC\n",
    "\n",
    "\n",
    "118.在UNIX平台下SYBASE可以应用那些客户端( )\n",
    "A.sybase central\n",
    "B.jisql\n",
    "C.optdiag\n",
    "D.isql\n",
    "\n",
    "\n",
    "↑答案：BD\n",
    "\n",
    "\n",
    "119.SQL server安装程序安装了4个系统数据库，下面哪是系统数据库。（ ）\n",
    "A.msdb\n",
    "B.modl\n",
    "C.master\n",
    "D.pub\n",
    "\n",
    "\n",
    "↑答案：ABC\n",
    "\n",
    "\n",
    "120.ASM不支持以下哪些文件？\n",
    "A.数据文件\n",
    "B.init.ora文件\n",
    "C.spfile\n",
    "D.Redo-log文件\n",
    "E.密码文件\n",
    "\n",
    "\n",
    "↑答案：BE\n",
    "\n",
    "\n",
    "121.IDS中BLOBSPACES存储的数据类型是___\n",
    "A.byte\n",
    "B.clob\n",
    "C.smallint\n",
    "D.text\n",
    "\n",
    "\n",
    "↑答案：AD\n",
    "\n",
    "\n",
    "122.通过$MYSQL_HOME/bin下的哪些命令能启动MySQL服务器？\n",
    "A.mysql\n",
    "B.mysqladmin\n",
    "C.mysqld_safe\n",
    "D.mysqld\n",
    "\n",
    "\n",
    "↑答案：CD\n",
    "\n",
    "\n",
    "123.下面哪两种情况数据库header增长在数据块中？\n",
    "A.当更多的行在数据块中需要迁移时\n",
    "B.当增大数据块的PCTFREE值\n",
    "C.当row directories 需要更多 row entries\n",
    "D.当更多的事物槽被配置时\n",
    "\n",
    "\n",
    "↑答案：CD\n",
    "\"\"\""
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Scala",
   "language": "scala",
   "name": "scala"
  },
  "language_info": {
   "codemirror_mode": "text/x-scala",
   "file_extension": ".scala",
   "mimetype": "text/x-scala",
   "name": "scala211",
   "nbconvert_exporter": "script",
   "pygments_lexer": "scala",
   "version": "2.11.11"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
